Re: [GENERAL] pg_class missing

Looks like you haven't initialised the database.

From the Administrators Guide:

"16. Create the database. Do NOT do the following as root!  This would be a
major security hole. Type initdb"

executing initdb should generate your base directory.


More info is available in the User and Administration guides.

HTH,

S.

>I want to use postgresql.
>
>The error message is:
>/usr/bin/postmaster does not find the database system
>
>The problem seems to be:
> file /var/lib/pgsql/base/template1/pg_class is missing.
>
>in fact I can only find up to /var/lib/pgsgl/
>
>How do I create the missing directories and file(s) ?
>
>I installed RedHat Linux from Mandrake.
>
>Thanks
>
>Phil Oelkers
>Database Analyst - Team O
>Experian DirectTech
>
>
>************
+--------------------------+--------------------------------------+
| Stuart C. G. Rison       | Ludwig Institute for Cancer Research |
+--------------------------+ 91 Riding House Street               |
| N.B. new phone code!!    | London, W1P 8BT                      |
| Tel. +44 (0)207 878 4041 | UNITED KINGDOM                       |
| Fax. +44 (0)207 878 4040 | stuart@ludwig.ucl.ac.uk              |
+--------------------------+--------------------------------------+